CREATE TABLE [dbo].[tb_informacionBancaria]
(
[IDInformacionBancaria] [int] NOT NULL IDENTITY(1, 1),
[Bilioteca] [int] NULL,
[Banco] [int] NULL,
[Localidad] [int] NULL,
[NroSucursal] [int] NULL,
[TipoCuenta] [int] NULL,
[NroCuentan] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CBU] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AltaConabip] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_informacionBancaria] ADD CONSTRAINT [PK_tb_informacionBancaria] PRIMARY KEY CLUSTERED  ([IDInformacionBancaria]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_informacionBancaria] WITH NOCHECK ADD CONSTRAINT [FK_tb_informacionBancaria_tb_Bancos] FOREIGN KEY ([Banco]) REFERENCES [dbo].[tb_Bancos] ([idBanco]) NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[tb_informacionBancaria] WITH NOCHECK ADD CONSTRAINT [FK_tb_informacionBancaria_Tb_Biliotecas] FOREIGN KEY ([Bilioteca]) REFERENCES [dbo].[Tb_Biliotecas] ([idbiblioteca]) NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[tb_informacionBancaria] WITH NOCHECK ADD CONSTRAINT [FK_tb_informacionBancaria_tb_Localidades] FOREIGN KEY ([Localidad]) REFERENCES [dbo].[tb_Localidades] ([idLocalidad])
GO
ALTER TABLE [dbo].[tb_informacionBancaria] WITH NOCHECK ADD CONSTRAINT [FK_tb_informacionBancaria_tb_TiposDeCuentaBancaria] FOREIGN KEY ([TipoCuenta]) REFERENCES [dbo].[tb_TiposDeCuentaBancaria] ([idTipoCuenta])
GO
ALTER TABLE [dbo].[tb_informacionBancaria] NOCHECK CONSTRAINT [FK_tb_informacionBancaria_tb_Bancos]
GO
ALTER TABLE [dbo].[tb_informacionBancaria] NOCHECK CONSTRAINT [FK_tb_informacionBancaria_Tb_Biliotecas]
GO
